package com.sise.studentInfoSystem.mapper;


import com.sise.studentInfoSystem.domain.Prehensive;
import com.sise.studentInfoSystem.domain.ProfrssionalSkills;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.ArrayList;
import java.util.List;

public interface PrehensiveMapper {

    @Insert("Insert into tb_prehensive(stu_id,prehensive_performance_evaluation_content,point,status) value(#{stuId},#{prehensivePerformanceEvaluationContent},#{point},#{status})")
    int InsetPrehensive(Prehensive prehensive);

    @Delete("delete from tb_prehensive where stu_id = #{stuId} ")
    int deletePrehensive(String stuId);

    @Select("select * from tb_prehensive where stu_id = #{stuId} ")
    List<Prehensive> findPrehensive(String stuId);

    @Update("update tb_prehensive set status='${status}',msg=#{msg} where stu_id = #{stuId}")
    int changeStatus(String stuId, String status, String msg);
}
